SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 46775: Double quotation marks in the description of a staging table causes SAS® IT Resource Management to fail

DetailsAboutRate It

A SAS IT Resource Management staging job might fail, issuing the following note and error messages:

NOTE 138-205: Line generated by the macro variable "DOTABLE".                                                                       
ERROR 71-63: The value specified for the LABEL option is too long.

This error occurs because a staged table contains double quotation marks in its description. The problem occurs even when the table contains balanced double quotation marks. The SAS IT Resource Management client fails as a result of actions performed against any staging or aggregation job referencing the staged table that submits SAS code to the SASITRM application server. The following list contains examples of such actions that can cause the failure:

  • selecting the Code tab for code generation transformation
  • deploying a staging or aggregation job
  • modifying a staging or aggregation job
  • running staging or aggregation jobs from the SAS IT Resource Management client
  • running SAS code from the SAS code editor
  • implementing any action (for example, purging, deleting, or modifying) that can be performed on a staged table

To circumvent this error:

  1. Remove any double quotation marks that are found in the description of the staged table. This description is located on the General tab in the staged table properties.
  2. Terminate the current SAS Workspace Server session by disconnecting and reconnecting the SAS IT Resource Management client. Terminate the session before you perform any action that involves submitting SAS code to the application server.


Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS IT Resource Managementz/OS3.23.49.2 TS2M39.4 TS1M1
Microsoft® Windows® for x643.23.49.2 TS2M39.4 TS1M1
Microsoft Windows Server 2003 Datacenter Edition3.29.2 TS2M3
Microsoft Windows Server 2003 Enterprise Edition3.29.2 TS2M3
Microsoft Windows Server 2003 Standard Edition3.29.2 TS2M3
Microsoft Windows Server 2003 for x643.29.2 TS2M3
Microsoft Windows Server 20083.29.2 TS2M3
Microsoft Windows Server 2008 for x643.23.49.2 TS2M39.4 TS1M1
Microsoft Windows XP Professional3.29.2 TS2M3
Windows 7 Enterprise 32 bit3.29.2 TS2M3
Windows 7 Enterprise x643.23.49.2 TS2M39.4 TS1M1
Windows 7 Home Premium 32 bit3.29.2 TS2M3
Windows 7 Home Premium x643.29.2 TS2M3
Windows 7 Professional 32 bit3.29.2 TS2M3
Windows 7 Professional x643.23.49.2 TS2M39.4 TS1M1
Windows 7 Ultimate 32 bit3.29.2 TS2M3
Windows 7 Ultimate x643.29.2 TS2M3
Windows Vista3.29.2 TS2M3
Windows Vista for x643.29.2 TS2M3
64-bit Enabled AIX3.23.49.2 TS2M39.4 TS1M1
64-bit Enabled HP-UX3.23.49.2 TS2M39.4 TS1M1
64-bit Enabled Solaris3.23.49.2 TS2M39.4 TS1M1
HP-UX IPF3.23.49.2 TS2M39.4 TS1M1
Linux3.23.49.2 TS2M39.4 TS1M1
Linux for x643.23.49.2 TS2M39.4 TS1M1
Solaris for x643.23.49.2 TS2M39.4 TS1M1
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.